<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>Ananas Library: Исходный файл asqltable.h</title>
<link href="doxygen.css" rel="stylesheet" type="text/css">
<link href="tabs.css" rel="stylesheet" type="text/css">
</head><body>
<!-- Создано системой Doxygen 1.5.6 -->
<div class="navigation" id="top">
  <div class="tabs">
    <ul>
      <li><a href="index.html"><span>Титульная&nbsp;страница</span></a></li>
      <li><a href="annotated.html"><span>Классы</span></a></li>
      <li class="current"><a href="files.html"><span>Файлы</span></a></li>
    </ul>
  </div>
<h1>asqltable.h</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">/****************************************************************************</span>
<a name="l00002"></a>00002 <span class="comment">** $Id: asqltable.h,v 1.49 2007/09/04 13:30:23 app Exp $</span>
<a name="l00003"></a>00003 <span class="comment">**</span>
<a name="l00004"></a>00004 <span class="comment">** Header file of the Ananas database table of Ananas</span>
<a name="l00005"></a>00005 <span class="comment">** Designer and Engine applications</span>
<a name="l00006"></a>00006 <span class="comment">**</span>
<a name="l00007"></a>00007 <span class="comment">** Created : 20031201</span>
<a name="l00008"></a>00008 <span class="comment">**</span>
<a name="l00009"></a>00009 <span class="comment">** Copyright (C) 2003-2004 Leader InfoTech.  All rights reserved.</span>
<a name="l00010"></a>00010 <span class="comment">**</span>
<a name="l00011"></a>00011 <span class="comment">** This file is part of the Library of the Ananas</span>
<a name="l00012"></a>00012 <span class="comment">** automation accounting system.</span>
<a name="l00013"></a>00013 <span class="comment">**</span>
<a name="l00014"></a>00014 <span class="comment">** This file may be distributed and/or modified under the terms of the</span>
<a name="l00015"></a>00015 <span class="comment">** GNU General Public License version 2 as published by the Free Software</span>
<a name="l00016"></a>00016 <span class="comment">** Foundation and appearing in the file LICENSE.GPL included in the</span>
<a name="l00017"></a>00017 <span class="comment">** packaging of this file.</span>
<a name="l00018"></a>00018 <span class="comment">**</span>
<a name="l00019"></a>00019 <span class="comment">** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE</span>
<a name="l00020"></a>00020 <span class="comment">** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.</span>
<a name="l00021"></a>00021 <span class="comment">**</span>
<a name="l00022"></a>00022 <span class="comment">** See http://www.leaderit.ru/page=ananas or email sales@leaderit.ru</span>
<a name="l00023"></a>00023 <span class="comment">** See http://www.leaderit.ru/gpl/ for GPL licensing information.</span>
<a name="l00024"></a>00024 <span class="comment">**</span>
<a name="l00025"></a>00025 <span class="comment">** Contact org@leaderit.ru if any conditions of this licensing are</span>
<a name="l00026"></a>00026 <span class="comment">** not clear to you.</span>
<a name="l00027"></a>00027 <span class="comment">**</span>
<a name="l00028"></a>00028 <span class="comment">**********************************************************************/</span>
<a name="l00029"></a>00029 
<a name="l00030"></a>00030 <span class="preprocessor">#ifndef ASQLTABLE_H</span>
<a name="l00031"></a>00031 <span class="preprocessor"></span><span class="preprocessor">#define ASQLTABLE_H</span>
<a name="l00032"></a>00032 <span class="preprocessor"></span><span class="preprocessor">#include &lt;qsqlcursor.h&gt;</span>
<a name="l00033"></a>00033 <span class="preprocessor">#include &lt;qdict.h&gt;</span>
<a name="l00034"></a>00034 <span class="preprocessor">#include "acfg.h"</span>
<a name="l00035"></a>00035 <span class="comment">//#include "aaregister.h"</span>
<a name="l00036"></a>00036 <span class="comment">//#include "adatarecord.h"</span>
<a name="l00037"></a>00037 
<a name="l00038"></a>00038 <span class="comment">// temporray define for old definitions</span>
<a name="l00039"></a>00039 <span class="preprocessor">#define aSQLTable aDataTable</span>
<a name="l00040"></a>00040 <span class="preprocessor"></span>
<a name="l00041"></a>00041 
<a name="l00042"></a>00042 <span class="keyword">class </span><a class="code" href="classaDatabase.html" title="Класс для работы с СУБД. Ananas Data Abstraction Layer. Наследует...">aDatabase</a>;
<a name="l00043"></a>00043 <span class="keyword">class </span>aSQLField;
<a name="l00044"></a>00044 
<a name="l00054"></a><a class="code" href="classaDataTable.html">00054</a> <span class="keyword">class  </span>ANANAS_EXPORT <a class="code" href="classaDataTable.html" title="Определяет программный интерфейс модели данных...">aDataTable</a> : <span class="keyword">public</span> QSqlCursor
<a name="l00055"></a>00055 {
<a name="l00056"></a>00056 <span class="keyword">public</span>:
<a name="l00057"></a>00057         <a class="code" href="classaDatabase.html" title="Класс для работы с СУБД. Ananas Data Abstraction Layer. Наследует...">aDatabase</a>*      db;
<a name="l00058"></a>00058         QString         tableName;
<a name="l00059"></a>00059         <span class="keywordtype">bool</span>            selected;
<a name="l00060"></a>00060         
<a name="l00061"></a>00061                                 aSQLTable( aCfgItem context, <a class="code" href="classaDatabase.html" title="Класс для работы с СУБД. Ananas Data Abstraction Layer. Наследует...">aDatabase</a> *adb );
<a name="l00062"></a>00062                                 aSQLTable( <span class="keyword">const</span> QString &amp;tname, <a class="code" href="classaDatabase.html" title="Класс для работы с СУБД. Ananas Data Abstraction Layer. Наследует...">aDatabase</a> *adb );
<a name="l00063"></a>00063         <span class="keyword">virtual</span>         ~aSQLTable();
<a name="l00064"></a>00064         <span class="keywordtype">void</span>            init( aCfgItem context, <a class="code" href="classaDatabase.html" title="Класс для работы с СУБД. Ananas Data Abstraction Layer. Наследует...">aDatabase</a> *adb );
<a name="l00065"></a>00065         <span class="keywordtype">void</span>            setObject(aCfgItem context);
<a name="l00066"></a>00066         <span class="keywordtype">void</span>            appendField( aSQLField * fieldinfo );
<a name="l00067"></a>00067         <span class="keywordtype">void</span>            insertField( <span class="keywordtype">int</span> pos, aSQLField * fieldinfo );
<a name="l00068"></a>00068         <span class="keywordtype">void</span>            removeField( <span class="keywordtype">int</span> pos );
<a name="l00069"></a>00069         <span class="keywordtype">void</span>            clearFields();
<a name="l00070"></a>00070         <span class="keywordtype">bool</span>            checkStructure( <span class="keywordtype">bool</span> update );
<a name="l00071"></a>00071         <span class="keywordtype">long</span>            getMdObjId();
<a name="l00072"></a>00072         Q_ULLONG        getIdd();
<a name="l00073"></a>00073         <span class="keywordtype">void</span>            printRecord();
<a name="l00074"></a>00074         <span class="comment">//QDict&lt;QVariant&gt; getUserFilter();</span>
<a name="l00075"></a>00075         <span class="comment">//void          setUserFilter( QDict&lt;QVariant&gt; );</span>
<a name="l00076"></a>00076         
<a name="l00077"></a>00077         <span class="keyword">virtual</span> QVariant        value ( <span class="keywordtype">int</span> i );
<a name="l00078"></a>00078         <span class="keyword">virtual</span> QVariant        value ( <span class="keyword">const</span> QString &amp; name );
<a name="l00079"></a>00079         <span class="keyword">virtual</span> <span class="keywordtype">void</span>            setValue ( <span class="keywordtype">int</span> i, QVariant value );
<a name="l00080"></a>00080         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            setValue ( <span class="keyword">const</span> QString &amp; name, QVariant value );
<a name="l00081"></a>00081         <span class="keyword">virtual</span> QVariant        sysValue ( <span class="keyword">const</span> QString &amp; name );
<a name="l00082"></a>00082         <span class="keyword">virtual</span> <span class="keywordtype">void</span>            setSysValue ( <span class="keyword">const</span> QString &amp; name, QVariant value );
<a name="l00083"></a>00083         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            sysFieldExists( <span class="keyword">const</span> QString &amp; name );
<a name="l00084"></a>00084 
<a name="l00085"></a>00085         <span class="keyword">virtual</span> QSqlRecord*     primeInsert();
<a name="l00086"></a>00086 <span class="comment">//      virtual QSqlRecord*     primeUpdate();</span>
<a name="l00087"></a>00087 
<a name="l00088"></a>00088         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            select( <span class="keyword">const</span> QString &amp; filter=<span class="stringliteral">""</span>, <span class="keywordtype">bool</span> usefltr = <span class="keyword">true</span> );
<a name="l00089"></a>00089         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            select( Q_ULLONG <span class="keywordtype">id</span> );
<a name="l00090"></a>00090         <span class="keyword">virtual</span> <span class="keywordtype">void</span>            clearFilter();
<a name="l00091"></a>00091         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            setFilter( <span class="keyword">const</span> QString &amp;name, <span class="keyword">const</span> QVariant &amp;value );
<a name="l00092"></a>00092         <span class="keyword">virtual</span> <span class="keywordtype">void</span>            setFilter( <span class="keyword">const</span> QString&amp; );
<a name="l00093"></a>00093         <span class="keyword">virtual</span> QString         getFilter();
<a name="l00094"></a>00094         <span class="keyword">virtual</span> QString         getNFilter();
<a name="l00095"></a>00095         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            exec( QString query );
<a name="l00096"></a>00096         <span class="keyword">virtual</span> QStringList     getUserFields();
<a name="l00097"></a>00097         <span class="keyword">virtual</span> ERR_Code        setMarkDeleted( <span class="keywordtype">bool</span> Deleted );
<a name="l00098"></a>00098         <span class="keyword">virtual</span> <span class="keywordtype">bool</span>            isMarkDeleted();
<a name="l00099"></a>00099         QString                 sqlFieldName ( <span class="keyword">const</span> QString &amp; userFieldName ) <span class="keyword">const</span>;
<a name="l00100"></a>00100 
<a name="l00101"></a>00101         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> New();
<a name="l00102"></a>00102         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> Copy();
<a name="l00103"></a>00103         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> Delete();
<a name="l00104"></a>00104         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> Update();
<a name="l00105"></a>00105 
<a name="l00106"></a>00106         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> seek ( <span class="keywordtype">int</span> i, <span class="keywordtype">bool</span> relative = FALSE );
<a name="l00107"></a>00107         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> next ();
<a name="l00108"></a>00108         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> prev ();
<a name="l00109"></a>00109         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> first ();
<a name="l00110"></a>00110         <span class="keyword">virtual</span> <span class="keywordtype">bool</span> last ();
<a name="l00111"></a>00111 
<a name="l00112"></a>00112 
<a name="l00113"></a>00113 <span class="keyword">protected</span>:
<a name="l00114"></a>00114         QVariant        calcFieldValue( <span class="keyword">const</span> QString &amp;name );
<a name="l00115"></a>00115         <span class="keyword">virtual</span>         QVariant calculateField( <span class="keyword">const</span> QString &amp;name );
<a name="l00116"></a>00116         <span class="keyword">virtual</span>         QVariant calc_obj(<span class="keywordtype">int</span> fid,Q_ULLONG idd);
<a name="l00117"></a>00117         <span class="keyword">virtual</span>         QVariant calc_rem(<span class="keywordtype">int</span> fid,Q_ULLONG <span class="keywordtype">id</span>);
<a name="l00118"></a>00118         <span class="keywordtype">void</span>            insertFieldInfo(aCfgItem cobj, <span class="keywordtype">bool</span> calculated=<span class="keyword">true</span>);
<a name="l00119"></a>00119         
<a name="l00120"></a>00120         <span class="keywordtype">long</span>            mdobjId;
<a name="l00121"></a>00121 
<a name="l00122"></a>00122 <span class="keyword">private</span>:
<a name="l00123"></a>00123 <span class="comment">//      bool fNewNotUpdated;</span>
<a name="l00124"></a>00124         aCfgItem                obj;
<a name="l00125"></a>00125         aCfgItem                init_obj;
<a name="l00126"></a>00126         <a class="code" href="classaCfg.html" title="Класс реализует програмный интерфейс доступа...">aCfg</a>*                   md;
<a name="l00127"></a>00127         QDict&lt;QObject&gt;  p_cat;
<a name="l00128"></a>00128         QDict&lt;QObject&gt;  p_doc;
<a name="l00129"></a>00129         QDict&lt;QObject&gt;  p_reg;
<a name="l00130"></a>00130         QMap&lt;int,aCfgItem&gt; mapCat, mapReg, mapDoc;
<a name="l00131"></a>00131         QMap&lt;int,QString&gt; mapDim,mapSum;
<a name="l00132"></a>00132         QStringList             fildsList;
<a name="l00133"></a>00133         QDict&lt;QString&gt;  fnames;
<a name="l00134"></a>00134         QDict&lt;QVariant&gt; userFilter;
<a name="l00135"></a>00135 <span class="comment">//      QDict&lt;aDataField&gt; dataRecord;</span>
<a name="l00136"></a>00136 <span class="comment">//      aDataRecord dataRecord;</span>
<a name="l00137"></a>00137 <span class="comment">//      QSqlRecord r;</span>
<a name="l00138"></a>00138 };
<a name="l00139"></a>00139 
<a name="l00140"></a>00140 <span class="preprocessor">#endif</span>
</pre></div></div>
<hr size="1"><address style="text-align: right;"><small>Документация по Ananas Library. Последние изменения: Sun Feb 1 21:47:14 2009. Создано системой&nbsp;
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.6 </small></address>
</body>
</html>
